from app import db

#姓名大全列表
class NameList(db.Model):
    __tablename__ = 'namelist'
    id = db.Column(db.Integer,primary_key=True)
    surName = db.Column(db.String(4)) #姓氏
    surNamePin = db.Column(db.String(64)) #姓氏拼音
    sex = db.Column(db.Integer) #性别 男1 女0
    full_name = db.Column(db.Text) #全名
    name_word = db.Column(db.String(16)) #名字

#精选姓名大全列表
class GoodNameList(db.Model):
    __tablename__ = 'goodnamelist'
    id = db.Column(db.Integer,primary_key=True)
    surName = db.Column(db.String(4)) #姓氏
    sex = db.Column(db.Integer) #性别 男1 女0
    full_name = db.Column(db.String(16)) #全名
    name_word = db.Column(db.String(16)) #名字词

#五行汉字查询
class Wxhanzi(db.Model):
    __tablename__ = 'wxhanzi'
    id = db.Column(db.Integer,primary_key=True)
    wx = db.Column(db.String(4))
    wx_py = db.Column(db.String(6))
    hanzi = db.Column(db.String(4))

#唐诗诗人表
class Poets(db.Model):
    __tablename__ = 'poets'
    id = db.Column(db.Integer,primary_key=True)
    name = db.Column(db.String(16))
    created_at = db.Column(db.DateTime)
    updated_at = db.Column(db.DateTime)

#唐诗内容表
class Poetries(db.Model):
    __tablename__ = 'poetries'
    id = db.Column(db.Integer,primary_key=True)
    title = db.Column(db.String(100))
    content = db.Column(db.Text)
    poet_id = db.Column(db.Integer)
    created_at = db.Column(db.DateTime)
    updated_at = db.Column(db.DateTime)

#万年历记录天干地支
class Lunar(db.Model):
    __tablename__ = 'lunar'
    GregorianDateTime=db.Column(db.DateTime,primary_key=True)
    LunarDateTime = db.Column(db.String(100))
    LunarShow= db.Column(db.String(100))
    IsJieJia= db.Column(db.String(100))
    LJie= db.Column(db.String(100))
    GJie= db.Column(db.String(100))
    Yi= db.Column(db.String(100))
    Ji= db.Column(db.String(100))
    ShenWei= db.Column(db.String(100))
    Taishen= db.Column(db.String(100))
    Chong= db.Column(db.String(100))
    SuiSha= db.Column(db.String(100))
    WuxingJiazi= db.Column(db.String(100))
    WuxingNaYear= db.Column(db.String(100))
    WuxingNaMonth= db.Column(db.String(100))
    WuxingNaDay= db.Column(db.String(100))
    MoonName= db.Column(db.String(100))
    XingEast= db.Column(db.String(100))
    XingWest= db.Column(db.String(100))
    PengZu= db.Column(db.String(100))
    JianShen= db.Column(db.String(100))
    TianGanDiZhiYear= db.Column(db.String(100))
    TianGanDiZhiMonth= db.Column(db.String(100))
    TianGanDiZhiDay= db.Column(db.String(100))
    LMonthName= db.Column(db.String(100))
    LYear= db.Column(db.String(100))
    LMonth= db.Column(db.String(100))
    LDay= db.Column(db.String(100))
    SolarTermName= db.Column(db.String(100))

#流行字库
class PopularWord(db.Model):
    __tablename__ = 'popularword'
    id = db.Column(db.Integer,primary_key=True)
    word = db.Column(db.String(2))
    sex = db.Column(db.Integer) #性别 男1 女0
    fraction = db.Column(db.Integer) #最大100分
    year = db.Column(db.Integer) #2019
